package com.ping.model;

import com.jfinal.plugin.activerecord.Model;

public class Store extends BaseModel<Model>{
	public static final String TABLE_NAME = "monkey_store";
	
	public static final String UUID = "uuid";
	public static final String MARKET = "market";
	public static final String NAME = "name";
	public static final String PRELETTER = "preletter";
	public static final String HOT = "hot";
	public static final String ADDR = "addr";
	
	public static final String SQL_GET_STORE_NAME=
			"SELECT name FROM monkey_store WHERE uuid=?";
	
	public static final String SQL_GET_STORES_IN_MARKET = 
			"SELECT * FROM monkey_store WHERE market=? ORDER BY preletter";
}
